/*
 Navicat Premium Data Transfer

 Source Server         : sql server
 Source Server Type    : SQL Server
 Source Server Version : 16001135 (16.00.1135)
 Source Catalog        : Graduate Admission System
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001135 (16.00.1135)
 File Encoding         : 65001

 Date: 06/12/2024 21:52:20
*/


-- ----------------------------
-- Table structure for 考生信息表
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[考生信息表]') AND type IN ('U'))
	DROP TABLE [dbo].[考生信息表]
GO

CREATE TABLE [dbo].[考生信息表] (
  [name] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [idnumber] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [examnumber] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [origin] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [undergradmajor] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [email] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [phone] varchar(11) COLLATE Chinese_PRC_CI_AS  NULL,
  [undergradschool] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[考生信息表] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of 考生信息表
-- ----------------------------
INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'张三', N'110101199001010001', N'001', N'北京', N'哲学', N'zhangsan@qq.com', N'13800138001', N'北京大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'李四', N'110101199001010002', N'002', N'上海', N'应用经济学', N'lisi@163.com', N'13800138002', N'上海交通大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'王五', N'110101199001010003', N'003', N'广州', N'金融', N'wangwu@qq.com', N'13800138003', N'华南理工大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'赵六', N'110101199001010004', N'004', N'深圳', N'应用统计', N'zhaoliu@163.com', N'13800138004', N'深圳大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙七', N'110101199001010005', N'005', N'杭州', N'国际商务', N'sunqi@qq.com', N'13800138005', N'浙江大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'周八', N'110101199001010006', N'006', N'成都', N'法学', N'zhouba@163.com', N'13800138006', N'电子科技大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'吴九', N'110101199001010007', N'007', N'重庆', N'社会学', N'wujiu@qq.com', N'13800138007', N'重庆大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'郑十', N'110101199001010008', N'008', N'武汉', N'历史学', N'zhengshi@163.com', N'13800138008', N'武汉大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'钱十一', N'110101199001010009', N'009', N'南京', N'政治学', N'qianshiyi@qq.com', N'13800138009', N'南京大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙十二', N'110101199001010010', N'010', N'天津', N'经济学', N'sunshi@qq.com', N'13800138010', N'南开大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'王十三', N'110101199001010011', N'011', N'西安', N'计算机科学', N'wangshi@qq.com', N'13800138011', N'西安交通大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'李十四', N'110101199001010012', N'012', N'长沙', N'软件工程', N'lishi@163.com', N'13800138012', N'中南大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'张十五', N'110101199001010013', N'013', N'郑州', N'机械工程', N'zhangshi@qq.com', N'13800138013', N'郑州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'赵十六', N'110101199001010014', N'014', N'济南', N'土木工程', N'zhaoshi@163.com', N'13800138014', N'山东大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙十七', N'110101199001010015', N'015', N'沈阳', N'电气工程', N'sunshi@qq.com', N'13800138015', N'东北大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'周十八', N'110101199001010016', N'016', N'哈尔滨', N'自动化', N'zhoushi@163.com', N'13800138016', N'哈尔滨工业大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'吴十九', N'110101199001010017', N'017', N'昆明', N'材料科学与工程', N'wushi@qq.com', N'13800138017', N'昆明理工大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'郑二十', N'110101199001010018', N'018', N'兰州', N'环境工程', N'zhenger@163.com', N'13800138018', N'兰州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'钱二十一', N'110101199001010019', N'019', N'呼和浩特', N'生物工程', N'qianer@qq.com', N'13800138019', N'内蒙古大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙二十二', N'110101199001010020', N'020', N'南昌', N'食品科学与工程', N'suner@qq.com', N'13800138020', N'南昌大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'王二十三', N'110101199001010021', N'021', N'合肥', N'化学工程', N'waner@qq.com', N'13800138021', N'中国科学技术大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'李二十四', N'110101199001010022', N'022', N'石家庄', N'纺织工程', N'lis@163.com', N'13800138022', N'河北工业大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'张二十五', N'110101199001010023', N'023', N'太原', N'矿业工程', N'zhangwu@qq.com', N'13800138023', N'太原理工大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'赵二十六', N'110101199001010024', N'024', N'西宁', N'地质工程', N'zhao@163.com', N'13800138024', N'青海大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'周二十八', N'110101199001010025', N'025', N'银川', N'石油工程', N'zhouba@163.com', N'13800138025', N'宁夏大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'吴二十九', N'110101199001010026', N'026', N'乌鲁木齐', N'交通运输工程', N'wujiu@qq.com', N'13800138026', N'新疆大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'郑三十', N'110101199001010027', N'027', N'拉萨', N'藏语言文学', N'zhengshi@163.com', N'13800138027', N'西藏大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'钱三十一', N'110101199001010028', N'028', N'贵阳', N'旅游管理', N'qianshiyi@qq.com', N'13800138028', N'贵州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙三十二', N'110101199001010029', N'029', N'南宁', N'园艺', N'sunshi@qq.com', N'13800138029', N'广西大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'王三十三', N'110101199001010030', N'030', N'海口', N'海洋科学', N'wangshi@qq.com', N'13800138030', N'海南大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'李三十四', N'110101199001010031', N'031', N'福州', N'生物技术', N'lishi@163.com', N'13800138031', N'福州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'张三十五', N'110101199001010032', N'032', N'长沙', N'环境科学', N'zhangshi@qq.com', N'13800138032', N'湖南大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'赵三十六', N'110101199001010033', N'033', N'郑州', N'土木工程', N'zhaoshi@163.com', N'13800138033', N'郑州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙三十七', N'110101199001010034', N'034', N'济南', N'电气工程', N'sunshi@qq.com', N'13800138034', N'山东大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'周三十八', N'110101199001010035', N'035', N'沈阳', N'自动化', N'zhoushi@163.com', N'13800138035', N'东北大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'吴三十九', N'110101199001010036', N'036', N'哈尔滨', N'材料科学与工程', N'wushi@qq.com', N'13800138036', N'哈尔滨工业大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'郑四十', N'110101199001010037', N'037', N'昆明', N'环境工程', N'zhenger@163.com', N'13800138037', N'昆明理工大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'钱四十一', N'110101199001010038', N'038', N'兰州', N'生物工程', N'qianer@qq.com', N'13800138038', N'兰州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙四十二', N'110101199001010039', N'039', N'呼和浩特', N'食品科学与工程', N'suner@qq.com', N'13800138039', N'内蒙古大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'王四十三', N'110101199001010040', N'040', N'南昌', N'化学工程', N'waner@qq.com', N'13800138040', N'南昌大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'李四十四', N'110101199001010041', N'041', N'合肥', N'纺织工程', N'lis@163.com', N'13800138041', N'中国科学技术大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'张四十五', N'110101199001010042', N'042', N'石家庄', N'矿业工程', N'zhangwu@qq.com', N'13800138042', N'河北工业大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'赵四十六', N'110101199001010043', N'043', N'太原', N'地质工程', N'zhao@163.com', N'13800138043', N'太原理工大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙四十七', N'110101199001010044', N'044', N'西宁', N'石油工程', N'sunqi@qq.com', N'13800138044', N'青海大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'周四十八', N'110101199001010045', N'045', N'银川', N'交通运输工程', N'zhouba@163.com', N'13800138045', N'宁夏大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'吴四十九', N'110101199001010046', N'046', N'乌鲁木齐', N'藏语言文学', N'wujiu@qq.com', N'13800138046', N'新疆大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'郑五十', N'110101199001010047', N'047', N'拉萨', N'旅游管理', N'zhengshi@163.com', N'13800138047', N'西藏大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'钱五十一', N'110101199001010048', N'048', N'贵阳', N'园艺', N'qianshiyi@qq.com', N'13800138048', N'贵州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙五十二', N'110101199001010049', N'049', N'南宁', N'海洋科学', N'sunshi@qq.com', N'13800138049', N'广西大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'王五十三', N'110101199001010050', N'050', N'海口', N'生物技术', N'wangshi@qq.com', N'13800138050', N'海南大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'李五十四', N'110101199001010051', N'051', N'福州', N'环境科学', N'lishi@163.com', N'13800138051', N'福州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'张五十五', N'110101199001010052', N'052', N'长沙', N'土木工程', N'zhangshi@qq.com', N'13800138052', N'湖南大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'赵五十六', N'110101199001010053', N'053', N'郑州', N'电气工程', N'zhaoshi@163.com', N'13800138053', N'郑州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙五十七', N'110101199001010054', N'054', N'济南', N'自动化', N'sunshi@qq.com', N'13800138054', N'山东大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'周五十八', N'110101199001010055', N'055', N'沈阳', N'材料科学与工程', N'zhoushi@163.com', N'13800138055', N'东北大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'吴五十九', N'110101199001010056', N'056', N'哈尔滨', N'环境工程', N'wushi@qq.com', N'13800138056', N'哈尔滨工业大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'郑六十', N'110101199001010057', N'057', N'昆明', N'生物工程', N'zhenger@163.com', N'13800138057', N'昆明理工大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'钱六十一', N'110101199001010058', N'058', N'兰州', N'食品科学与工程', N'qianer@qq.com', N'13800138058', N'兰州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙六十二', N'110101199001010059', N'059', N'呼和浩特', N'化学工程', N'suner@qq.com', N'13800138059', N'内蒙古大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'王六十三', N'110101199001010060', N'060', N'南昌', N'纺织工程', N'waner@qq.com', N'13800138060', N'南昌大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'李六十四', N'110101199001010061', N'061', N'合肥', N'矿业工程', N'lis@163.com', N'13800138061', N'中国科学技术大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'张六十五', N'110101199001010062', N'062', N'石家庄', N'地质工程', N'zhangwu@qq.com', N'13800138062', N'河北工业大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'赵六十六', N'110101199001010063', N'063', N'太原', N'石油工程', N'zhao@163.com', N'13800138063', N'太原理工大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙六十七', N'110101199001010064', N'064', N'西宁', N'交通运输工程', N'sunqi@qq.com', N'13800138064', N'青海大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'周六十八', N'110101199001010065', N'065', N'银川', N'藏语言文学', N'zhouba@163.com', N'13800138065', N'宁夏大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'吴六十九', N'110101199001010066', N'066', N'乌鲁木齐', N'旅游管理', N'wujiu@qq.com', N'13800138066', N'新疆大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'郑七十', N'110101199001010067', N'067', N'拉萨', N'园艺', N'zhengshi@163.com', N'13800138067', N'西藏大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'钱七十一', N'110101199001010068', N'068', N'贵阳', N'海洋科学', N'qianshiyi@qq.com', N'13800138068', N'贵州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙七十二', N'110101199001010069', N'069', N'南宁', N'生物技术', N'sunshi@qq.com', N'13800138069', N'广西大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'王七十三', N'110101199001010070', N'070', N'海口', N'环境科学', N'wangshi@qq.com', N'13800138070', N'海南大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'李七十四', N'110101199001010071', N'071', N'福州', N'土木工程', N'lishi@163.com', N'13800138071', N'福州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'张七十五', N'110101199001010072', N'072', N'长沙', N'电气工程', N'zhangshi@qq.com', N'13800138072', N'湖南大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'赵七十六', N'110101199001010073', N'073', N'郑州', N'自动化', N'zhaoshi@163.com', N'13800138073', N'郑州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙七十七', N'110101199001010074', N'074', N'济南', N'材料科学与工程', N'sunshi@qq.com', N'13800138074', N'山东大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'周七十八', N'110101199001010075', N'075', N'沈阳', N'环境工程', N'zhoushi@163.com', N'13800138075', N'东北大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'吴七十九', N'110101199001010076', N'076', N'哈尔滨', N'生物工程', N'wushi@qq.com', N'13800138076', N'哈尔滨工业大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'郑八十', N'110101199001010077', N'077', N'昆明', N'食品科学与工程', N'zhenger@163.com', N'13800138077', N'昆明理工大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'钱八十一', N'110101199001010078', N'078', N'兰州', N'化学工程', N'qianer@qq.com', N'13800138078', N'兰州大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙八十二', N'110101199001010079', N'079', N'呼和浩特', N'纺织工程', N'suner@qq.com', N'13800138079', N'内蒙古大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'王八十三', N'110101199001010080', N'080', N'南昌', N'矿业工程', N'waner@qq.com', N'13800138080', N'南昌大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'李八十四', N'110101199001010081', N'081', N'合肥', N'地质工程', N'lis@163.com', N'13800138081', N'中国科学技术大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'张八十五', N'110101199001010082', N'082', N'石家庄', N'石油工程', N'zhangwu@qq.com', N'13800138082', N'河北工业大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'赵八十六', N'110101199001010083', N'083', N'太原', N'交通运输工程', N'zhao@163.com', N'13800138083', N'太原理工大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'孙八十七', N'110101199001010084', N'084', N'西宁', N'藏语言文学', N'sunqi@qq.com', N'13800138084', N'青海大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'周八十八', N'110101199001010085', N'085', N'银川', N'旅游管理', N'zhouba@163.com', N'13800138085', N'宁夏大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'吴八十九', N'110101199001010086', N'086', N'乌鲁木齐', N'园艺', N'wujiu@qq.com', N'13800138086', N'新疆大学')
GO

INSERT INTO [dbo].[考生信息表] ([name], [idnumber], [examnumber], [origin], [undergradmajor], [email], [phone], [undergradschool]) VALUES (N'蔡长正', N'11111', N'100', N'天津', N'计算机', N'873056302@qq.com', N'13821071278', N'北京林业大学')
GO


-- ----------------------------
-- Primary Key structure for table 考生信息表
-- ----------------------------
ALTER TABLE [dbo].[考生信息表] ADD CONSTRAINT [PK_考生信息表] PRIMARY KEY CLUSTERED ([examnumber])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Foreign Keys structure for table 考生信息表
-- ----------------------------
ALTER TABLE [dbo].[考生信息表] ADD CONSTRAINT [FK_考生信息表_考生信息表] FOREIGN KEY ([examnumber]) REFERENCES [dbo].[考生信息表] ([examnumber]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

